{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Afkast","Vurdering","Noter"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Afkast","index":0,"n_rows":201,"n_cols":8,"rows_kept":201,"cut":false,"hidden":false,"merged":[[8,0,8,2],[34,0,34,2],[40,0,40,2],[50,0,50,2],[0,0,0,4],[10,3,10,4],[45,0,45,4],[3,1,3,5],[5,1,5,5],[55,0,55,2],[24,0,24,2],[29,0,29,2],[33,0,33,2],[10,0,10,2],[22,0,22,2],[25,0,25,2],[27,0,27,2],[31,0,31,2]]}
["Handelspris - Afkastmetoden"]
[]
[]
["Ejendom:"]
[]
["Adresse:"]
[]
[]
["Beregning af afkast"]
[]
["Dækningsbidrag",null,null,"DB pr. enhed",null,null,null,"Note"]
[]
[101," ha á",null,4000," kr",{"$f":"D13*A13","v":404000}," kr",1]
[301," årssøer á",null,5000," kr",{"$f":"D14*A14","v":1505000}," kr",2]
[null," prod. slagtesvin á",null,null," kr",0," kr",3]
[100," malkekøer med opdræt á",null,11000," kr",1100000," kr",4]
[null," slagtekalve á",null,null," kr",0," kr",5]
[null,null,null,null," kr",{"$f":"D18*A18","v":0}," kr",6]
[null,null,null,null," kr",{"$f":"D19*A19","v":0}," kr",7]
[null,null,null,null," kr",0," kr",8]
[null,null,null,152000," kr",0," kr",9]
[]
["Dækningsbidrag ialt",null,null,null," =       ",{"$f":"SUM(F13:F21)","v":3009000}," kr"]
[]
["Kontante kapacitetsomkostninger",null,null,123450," kr",null,null,10]
["Afskrivninger",null,null,730000," =          -",{"$f":"SUM(D25:D26)","v":853450}," kr",11]
[]
["Ejeraflønning",null,null,450000," =          -",{"$f":"D28","v":450000},null,12]
[]
["Betalingsrettigheder, årligt afkast",null,null,300000," =          +",{"$f":"D30","v":300000}," kr",13]
[]
["Afkast til forrentning",null,null,null,null,{"$f":"F23-F28+F30-F26","v":2005550}," kr",14]
[]
["Beregning af købspris"]
["Investering ved rente på ",null,null,5," pct.",{"$f":"IF(ISBLANK(D35),\"\",F32/D35*100)","v":40111000}," kr",15]
[]
[" + bolig",null,null,2000000," kr",null,null,16]
[null,null,null,null," kr",null,null,17]
[null,null,null,null," =          +",{"$f":"SUM(D37:D39)","v":2000000}," kr",18]
[]
[" - investeringsbehov"]
[null,null,null,null," kr",null,null,19]
[null,null,null,null," kr",null,null,20]
[null,null,null,null," =          -",{"$f":"SUM(D42:D44)","v":0}," kr",21]
[]
[" + overkapaciteter, der kan sælges til dagspris"]
[null,null,null,null," kr",null,null,22]
[null,null,null,null," kr",null,null,23]
[null,null,null,null," =          +",{"$f":"SUM(D47:D49)","v":0}," kr",24]
[]
[" + herlighedsværdi og andre forhold"]
[null,null,null,null," kr",null,null,25]
[null,null,null,null," kr",null,null,26]
[null,null,null,null," =          +",{"$f":"SUM(D52:D54)","v":0}," kr",27]
[]
["Rentabel pris (afrundet hele titusinder)",null,null,null,null,{"$f":"IF(ISBLANK(D35),0.0001,ROUND(F35+F39-F44+F54+F49,-4))","v":42110000}," kr",28]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[12345678,12345678,123456,123456789,123456,12345678,12,12]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"fjklasdæf"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,12345678]

{"sheet":"Vurdering","index":1,"n_rows":79,"n_cols":23,"rows_kept":79,"cut":false,"hidden":false,"merged":[]}
[null,"Handelspris - Vurderingsmetoden",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beregninger"]
[]
[null,"Jord, stuehus, andre bygninger, andre aktiver"]
[null,"Dyrkningsjord",null,100,"ha á kr.",150000," =",{"$f":"D4*F4","v":15000000}]
[null,"Jord - skov, eng mv.",null,12,"ha á kr.",45000," =",{"$f":"D5*F5","v":540000}]
[null,"Andre driftsbygninger",null,null,null,null,null,150000]
[null,"Stuehus",null,null,null,null,null,2000000]
[null,"Andre boliger"]
[null,"Heste"]
[null,"Herlighedsværdi"]
[null,"I alt",null,null,null,null,null,{"$f":"SUM(H4:H10)","v":17690000}]
[null,null,null,null,null,null,null,null,null,null,null,"Pr. stiplads"]
[null,"Staldanlæg",null,null,null,null,null,null,null,"Restværdi",null,"nypris",null,"Restlevetid af",null,"levetid i alt"]
[null,"Staldanlæg søer",null,101,"pladser á kr.",11250," =",{"$f":"D14*F14","v":1136250},null,{"$f":"N14/P14*L14","v":11250},null,15000,null,15,"år",20,"år"]
[null,"Staldanlæg smågrise",null,102,"pladser á kr.",500," =",{"$f":"D15*F15","v":51000},null,{"$f":"N15/P15*L15","v":500},null,2000,null,5,"år",20,"år"]
[null,"Staldanlæg slagtesvin",null,103,"pladser á kr.",750," =",77250,null,750,null,3000,null,5,"år",20,"år"]
[null,"Staldanlæg køer med opdræt",null,101,"pladser á kr.",22500," =",{"$f":"D17*F17","v":2272500},null,{"$f":"N17/P17*L17","v":22500},null,30000,null,15,"år",20,"år"]
[null,"Staldanlæg slagtekalve",null,103,"pladser á kr.",750," =",{"$f":"D18*F18","v":77250},null,{"$f":"N18/P18*L18","v":750},null,3000,null,5,"år",20,"år"]
[null,"Staldanlæg i alt",null,null,null,null,null,{"$f":"SUM(H14:H18)","v":3614250}]
[]
["Konto","Tekst",null,"Antal",null,"Kr./stk.",null,"Værdi"]
["1460 00 ","Orner ",null,4,null,4000,null,{"$f":"D22*F22","v":16000}]
["1461 10 ","Søer, drægtige ",null,250,null,null,null,0]
["1461 20 ","Søer, ikke drægtige ",null,50,null,null,null,0]
["1465 00 ","Gylte ",null,25,null,null,null,0]
["1469 01 ","Sopolte over 60 kg ",null,10,null,null,null,0]
["1469 11 ","Sopolte under 60 kg ",null,10,null,null,null,0]
["1472 00 ","Smågrise, sohold ",null,null,null,null,null,0]
["1472 13 ","Smågrise 7 - 20 kg ",null,null,null,null,null,0]
["1472 10 ","Smågrise 20 - 30 kg ",null,null,null,null,null,0]
["1481 11 ","Slagtesvin 30 - 45 kg ",null,null,null,null,null,0]
["1481 10 ","Slagtesvin 45 - 60 kg ",null,null,null,null,null,0]
["1481 00 ","Slagtesvin 30 - 60 kg ",null,null,null,null,null,0]
["1480 12 ","Slagtesvin 60 - 75 kg ",null,null,null,null,null,0]
["1480 11 ","Slagtesvin 75 - 90 kg ",null,null,null,null,null,0]
[]
[null,"Besætningsværdi svin i alt",null,null,null,null,null,{"$f":"IF(ISBLANK(G37),SUM(H22:H35),G37)","v":16000}]
[]
["Konto","Tekst",null,"Antal",null,"Kr./stk.",null,"Værdi"]
["1405 00 ","Køer ",null,100,null,null,null,{"$f":"D40*F40","v":0}]
["1420 00 ","Kvier over 2 år ",null,10,null,null,null,0]
["1425 00 ","Kvier 1 - 2 år ",null,40,null,null,null,0]
["1430 00 ","Kviekalve u. 1 år ",null,40,null,null,null,0]
["1450 01 ","Tyrekalve 1/2 – 1 år ",null,null,null,null,null,0]
["1450 02 ","Tyrekalve u. 1/2 år ",null,null,null,null,null,0]
[null,"Stude",null,20,null,5000,null,100000]
[null,null,null,null,null,null,null,0]
[]
[null,"Besætningsværdi kvæg i alt",null,null,null,null,null,{"$f":"IF(ISBLANK(G49),SUM(H40:H47),G49)","v":100000}]
[]
[]
[null,"Betalingsrettigheder",null,1000000,"stk á kr.",0.72,null,{"$f":"D52*F52","v":720000}]
[null,"Andre rettigheder",null,100,"stk á kr.",500,null,{"$f":"D53*F53","v":50000}]
[]
[null,"Maskiner",null,null,null,null,null,{"$f":"IF(ISBLANK(G55),SUM(H57:H68),G55)","v":1025000}]
[null,"Tekst",null,null,null,null,null,"Kr./stk."]
[null,"Traktor",null,null,null,null,null,750000]
[null,"såsæt",null,null,null,null,null,200000]
[null,"sprøjte",null,null,null,null,null,75000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Beholdninger"]
[null,"Beholdninger egen avl",null,20000,"FE/kg á kr.",1.5," =",{"$f":"D71*F71","v":30000}]
[null,"Salgsbeholdninger",null,50000,"FE/kg á kr.",1.4," =",70000]
[null,null,null,null,"FE/kg á kr.",null," =",0]
[null,null,null,null,null,null," =",{"$f":"D74*F74","v":0}]
[]
[null,"Fradrag for akut investeringsbehov (husk minus)"]
[null,null,null,null,null,null,null,-50000]
[]
[null,"I alt sum af enkeltaktivers værdi (afr. hele titusinder)",null,null,null,null,null,{"$f":"ROUND(H11+H19+H37+H49+H52+H53+H55+H71+H72+H73+H74+H77,-4)","v":23270000}]

{"sheet":"Noter","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}